@echo off
if [%1] == [] goto usage
if [%2] == [] goto usage
if [%3] == [] goto usage
if [%4] == [] goto usage

echo building tables .....
SQLCMD -S %1 -U %2 -P %3 -d %4 -i "TablesDropCreate.sql"

echo installing SPs .....
SP\install_sps.bat %1 %2 %3 %4


:pause
pause
goto end
:usage
echo usage: "installDB.bat <dbInstance> <dbUserName> <dbPassword> <dbName>"
pause
:end